package com.example.admin.service;


import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;

@Service
@RequiredArgsConstructor
public class MemberService {

    private final JdbcTemplate jdbcTemplate;


    public List<Map<String, Object>> memberList() {
        String sql = "select * from svc_member.member_inf m where m.product_code = ?";
        return jdbcTemplate.queryForList(sql, "DF");
    }

}
